AdEnrollDegree 
Logical Entity Name  AdEnrollDegree 
Default Table Name  AdEnrollDegree 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

AdEnrollDegree Columns 
ColumnName  Domain  Datatype  NULL  Definition 
AdEnrollDegreeID(PK)    int  NO 
 
AdEnrollID    int  NO 
 
AdDegreeID    int  NO 
 
DateAwarded    datetime  NO 
 
DateCleared    datetime  YES 
 
Comments    varchar(300)  YES 
 
UserID    int  YES 
 
DateAdded    datetime  YES 
 
DateLstMod    datetime  YES 
 
ModFlag    char(1)  YES 
 
ts    timestamp  YES 
 

AdEnrollDegree Primary and Unique Keys 
Key Name  Key Type  Keys 
AdEnrollDegree_AdEnrollDegreeID_U_C_IDX  PrimaryKey  AdEnrollDegreeID 

AdEnrollDegree Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 

AdEnrollDegree Check Constraints 
Check Constraint Name  CheckConstraint 

AdEnrollDegree Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

AdEnrollDegree Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.StudentEnrollmentPeriodDegree 
NO       
Physical (Microsoft SQL Server)
dbo.AdEnrollDegree 
NO       

AdEnrollDegree Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Logical  StudentEnrollment 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Academic Records 

AdEnrollDegree Data Movement Rules 
Name  Type  Rule Text/Value